package com.xy.bizportdemo.database.entity;

/**
 * Created by admin on 2016/11/23.
 */

public class SmsDBTableMessage {
    public static final String KEY_ID = "_id";
    public static final String KEY_ADDRESS = "address";
    public static final String KEY_BODY = "body";
    public static final String KEY_DATE = "date";
    public static final String KEY_TYPE = "type";
    public static final String KEY_SOURCE = "source";
    public static final String KEY_HAS_READ = "hasRead";
    public static final String KEY_BLOCK = "block";

    public static final String NAME = "tb_message";

    public static final String DROP_TABLE = " DROP TABLE IF EXISTS "
            + NAME;
    public static final String CREATE_TABLE = "create table  if not exists "
            + NAME +
            " ("
            + KEY_ID + " INTEGER PRIMARY KEY,"
            + KEY_ADDRESS + " TEXT,"
            + KEY_BODY + " TEXT,"
            + KEY_DATE + " TEXT,"
            + KEY_SOURCE + " INTEGER,"
            + KEY_HAS_READ + " INTEGER,"
            + KEY_BLOCK + " INTEGER,"
            + KEY_TYPE + " INTEGER"
            + ")";
}
